| AdGainfulEmploymentReportingDetails |
| Logical Entity Name | AdGainfulEmploymentReportingDetails |
| Default Table Name | AdGainfulEmploymentReportingDetails |
| Physical Only | NO |
| Definition | |
| Note |
| AdGainfulEmploymentReportingDetails Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
AdGainfulEmploymentReportingDetailsID |
int | NO | ||
AdGainfulEmploymentReportingID |
int | NO | ||
| SyCampusID | int | NO | ||
FaYearID |
char(2) | NO | ||
SyStudentID |
int | NO | ||
| AdEnrollID | int | NO | ||
| DOB | datetime | NO | ||
| SSN | char(9) | NO | ||
| LastName | char(25) | NO | ||
| ProgramAttendBeginDateForAY | datetime | NO | ||
| ProgramName | char(120) | NO | ||
| SySchoolStatusID | int | NO | ||
| IsTitleIV | bit | NO | ||
| PrivateLoanAmount | char(6) | YES | ||
| InstitutionalLoanAmount | char(6) | YES | ||
| TuitionAndFees | char(6) | YES | ||
| Exported | bit | NO | ||
| ProgramAttendBeginDate | datetime | NO | ||
| ProgramAttendEndDate | datetime | YES | ||
| AttendanceStatus | char(1) | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
UserId |
int | NO | ||
| ts | timestamp | NO |
| AdGainfulEmploymentReportingDetails Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_AdGainfulEmploymentReportingDetails_AdGainfulEmploymentReportingDetailsID | PrimaryKey | AdGainfulEmploymentReportingDetailsID |
| AdGainfulEmploymentReportingDetails Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| FaYear | Non-Identifying | One To Zero or More | FK_AdGainfulEmploymentReportingDetailsFaYearID_FaYearFaYearID | FaYearID | NO | YES | ||
| syStudent | Non-Identifying | One To Zero or More | FK_AdGainfulEmploymentReportingDetailsSyStudentID_SyStudentSyStudentID | SyStudentID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_AdGainfulEmploymentReportingDetailsUserID_SyStaffSyStaffID | UserId | NO | YES | ||
| AdGainfulEmploymentReporting | Non-Identifying | One To Zero or More | FK_AdGainfulEmpRepDetailsAdGainfulEmplRepID_AdGainfulEmpRepAdGainfulEmplRepID | AdGainfulEmploymentReportingID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| AdGainfulEmploymentReportingData | Non-Identifying | One To Zero or More | FK_AdGainfulEmpRepDataAdGainfulEmpRepDetailsID_AdGainfulEmpRepDetailsAdGainfulEmpRepDetailsID | NO | YES |
| AdGainfulEmploymentReportingDetails Check Constraints |
| Check Constraint Name | CheckConstraint |